Microsoft Excel Masterclass in Nottingham

  • Gain a solid understanding of Microsoft Excel’s basics and spreadsheet.
  • Learn how to use formulas and create pivot tables more effectively.
  • Become familiarised with the importance of status bar in Microsoft Excel.

Key Points About Microsoft Excel Masterclass in Nottingham

237 Learners Recommended

Duration: 1 Days*

Accredited: Yes

Enquire Now View Dates & Prices
Book Now in Nottingham

Microsoft Excel Masterclass

Overview 1
Outlines 2
FAQs 3
What's Included 4

Course Overview

This Microsoft Excel Masterclass is specially tailored for those who wish to use Excel in their work regularly and want to enhance their Excel skills. This one-day masterclass will help delegates to learn how to highlight cells containing text and how to create and edit worksheets. Along with this, delegates will gain knowledge of how to use formulas and functions as well as sort and filter detail data visually. Delegates will get an understanding of how to present summary information in a consumable and professional format.

They will also learn how to effectively use various excel formulas, tables and charts to manage the business process from small to large.

Show more

Course Outline

  • The Excel Tab Interface
  • The Tabs
  • The Main Components of the Workbook Screen
  • The Ribbon
  • Name Box
  • The Formula Bar
  • Worksheet Tab
  • Shortcuts
  • Showing and Collapsing the Ribbon
  • Understanding the Backstage View
  • Understanding Dialogue Boxes
  • Launching Dialogue Boxes
  • Understanding the Quick Access Toolbar
  • Changing the Location of the Bar
  • Modify Quick Access Commands
  • Add a Command
  • Remove a Command
  • Understanding the Status Bar
  • Understanding Filters
  • Applying a Filter
  • Performing an Alphabetical Sort
  • Performing a Numerical Sort
  • Creating a Table
  • Inserting or Deleting Table Records
  • Adding Table Column
  • Deleting Table Column
  • Deleting Table Record
  • Removing Duplicates
  • Modifying a Table
  • Sorting Data in a Table
  • Naming Tables
  • Resizing Tables
  • Deleting a Table
  • Understanding Conditional Formatting
  • Highlighting Cells Containing Values and Text
  • Highlighting Duplicate Values
  • Using Top/Bottom Rules
  • Applying Top/Bottom Rules
  • Top Bottom Rule Types
  • Using Data Bars
  • Using Colour Scales
  • Using Icon Sets
  • Creating Custom Rules
  • To Create a Custom Rule
  • The Conditional Formatting Rules Manager
  • Rules Manager
  • Clearing Rules
  • Using Sparklines
  • Using Formulas in Excel
  • Exploring Excel Functions
  • Using Functions in Excel
  • Insert Function Button
  • Working with Names and Ranges
  • Creating a Named Reference
  • Removing a Named Reference
  • IF Formulas
  • Common Logical Functions
  • Arguments used within IF Functions
  • Create a PivotTable from an Excel Data List
  • Add/Remove/Reorganise Data Fields
  • Changing the Pivot Table Design
  • Refresh Data/Change Data Source
  • Create and Modify a Pivot Chart
  • VLOOKUP
Show more

There are no formal prerequisites to attend this masterclass, but you should have some familiarity with computers and Windows 10.

The course is open for anyone who wishes to learn how to use Microsoft Excel.

The Microsoft Excel Masterclass Cost in United Kingdom Starts from £1865.00

Please see our Microsoft Excel Training courses available in United Kingdom

Custom Modes of Training

classroom

Classroom

 online

Online

 virtual

Virtual

 onsite

Onsite
telephone

Get More Information

Still have questions? We’re happy to help.

calendar

Dates & Prices

Choose a Location

Choose a Month

Learn from the comfort of your home or office

Join discussions via computer or mobile device

Interact with subject matter experts

40 Hours (on average)

90 Days Access

Certificate upon completion

Schedule and location of your choice

Save on travel costs

Monitor employee development

Key points about this course

237 Learners Recommended

Duration: 1 Days*

Accredited: Yes

Add additional features

6 Months Access - £ 77.00

1 Year Access - £ 154.00

Official Exam - £ 109.00

Personal career coach and career services

£ 1865.00

Enquire Enroll

Your online (Microsoft Excel Masterclass) package

Upon purchase you will receive a password via the email you used to purchase the course.

You will then be able to login to our online learning platform with your email and password.

You will have access to the platform for 90 days to complete your course.

Course Onsite Enquiry

Microsoft Excel Masterclass

Complete the steps below to receive a quote or more information

Your details

How many employees need training test?

Next Step

When would you like to take the course test?

How many employees need training?

Prev
Discover how we are doing

Our goal is to always provide training of the highest quality for your organisation.

We aim for customer satisfaction across all areas, including price, quality, and learning support. We always use the feedback from clients to continually improve and ensure we surpass expectation. Have a look at our customer reviews that showcase the standard we offer.

97% price

Response Rate

99% price

Positive Rating

Steps For Success

Leading Path To Success

works
People
also
Bought

People Also Bought

relatecourse

MSP® Foundation
relatecourse

Lean Six Sigma Black Belt
relatecourse

MSP® Foundation & Practitioner
relatecourse

Lean Six Sigma Green Belt
relatecourse

Lean Six Sigma Yellow Belt
relatecourse

Lean Six Sigma Black Belt Upgrade
Book Now

Looking For More Information

mail search cart call
open modal
open modal